home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / cashboxtotals.sql < prev    next >
Text File  |  2000-05-12  |  761b  |  23 lines
  1. /* RCSVER $Id: cashboxtotals.sql,v 1.2 1999-03-24 09:13:25-06 evan CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        cashboxcount
  6. * Date:        1/10/1999
  7. * memo:        Evan M. Ghormley    
  8. * Description:    Create the cashboxcount table. 
  9. * Changes:
  10. ************************************************************************* */
  11. CREATE TABLE cashboxtotals
  12. (
  13.      cashbox_total_seq    NUMBER(38) PRIMARY KEY,
  14.       batch_total_seq_num NUMBER(38),
  15.       acctday_total_seq_num        NUMBER(38),    
  16.       count_date        DATE,
  17.     cashbox_glid        NUMBER(38),
  18.     coin_total             NUMBER(20,2),
  19.     bill_total           NUMBER(20,2),
  20.     grand_total         NUMBER(20,2)
  21. );
  22.  
  23.